FaSSCR

EntityType | Independent
Logical Entity Name | FaSSCR
Default Table Name | FaSSCR
Logical Only | NO
Owner | dbo
Definition |
Note |

FaSSCR Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaSSCRID |  | INTEGER | NO |
SeqNum |  | VARCHAR(7) | YES |
SSNIndicator |  | VARCHAR(1) | YES |
SSN |  | VARCHAR(30) | YES |
LastName |  | VARCHAR(35) | YES |
FirstName |  | VARCHAR(35) | YES |
MiddleInitial |  | VARCHAR(1) | YES |
DOB |  | DATETIME | YES |
NewSSN |  | VARCHAR(30) | YES |
NewLastName |  | VARCHAR(35) | YES |
NewFirstName |  | VARCHAR(12) | YES |
NewMiddleInitial |  | VARCHAR(1) | YES |
NewDOB |  | DATETIME | YES |
StreetAddr1 |  | VARCHAR(40) | YES |
StreetAddr2 |  | VARCHAR(40) | YES |
City |  | VARCHAR(30) | YES |
State |  | VARCHAR(2) | YES |
Country |  | VARCHAR(25) | YES |
ZipCode |  | VARCHAR(17) | YES |
AddrEffectiveDate |  | DATETIME | YES |
AnticipatedCompletionDate |  | DATETIME | YES |
OldEnrollmentStatus |  | VARCHAR(1) | YES |
EnrollmentStatus |  | VARCHAR(1) | YES |
OldEnrollmentEffectiveDate |  | VARCHAR(8) | YES |
EnrollmentEffectiveDate |  | DATETIME | YES |
SchoolStudentID |  | INTEGER | YES |
syStudentID |  | INTEGER | YES |
AdEnrollID |  | INTEGER | YES |
syCampusID |  | INTEGER | YES |
AdTermID |  | INTEGER | YES |
ClockCredit |  | VARCHAR(1) | YES |
TermCreditsSched |  | INTEGER | YES |
TermHoursSched |  | INTEGER | YES |
TermStartDate |  | DATETIME | YES |
TermEndDate |  | DATETIME | YES |
BatchID |  | VARCHAR(30) | NO |
UserID |  | INTEGER | NO |
DateAdded |  | DATETIME | NO |
DateLstMod |  | DATETIME | NO |
ts |  | TIMESTAMP/DATE | NO |
SchoolID |  | CHAR(6) | YES |
BranchID |  | CHAR(2) | YES |
CredentialLevel |  | VARCHAR(2) | YES |
IsAddedToFile |  | BIT | YES |
MiddleName |  | VARCHAR(35) | YES |
OldMiddleName |  | VARCHAR(35) | YES |

FaSSCR Keys

Key Name | Key Type | Keys
FaSSCR_FaSSCRID_BatchID_U_N_IDX | Alternate Key | FaSSCRID, BatchID
FaSSCR_FaSSCRID_U_C_IDX | PrimaryKey | FaSSCRID
NK_FaSSCR_BatchID_SchoolID_BranchID | Inversion Entry | BatchID, SchoolID, BranchID

FaSSCR Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | syCampusID | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | UserID | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaSSCR Check Constraints

Check Constraint Name | CheckConstraint

FaSSCR Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaSSCR | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaSSCR | NO |  |  |

FaSSCR Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaSSCR Data Movement Rules

Name | Type | Rule Text/Value